Expedia Train Set Report

Dataset statistics

Number of variables	47
Number of observations	841115
Missing cells	1064609
Missing cells (%)	2.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.0 GiB
Average record size in memory	1.3 KiB

Variable types

Numeric	23
Categorical	24

Warnings

`srch_mobile_app` has constant value "0"	Constant
`srch_date_time` has a high cardinality: 23873 distinct values	High cardinality
`srch_visitor_id` has a high cardinality: 23101 distinct values	High cardinality
`srch_visitor_loc_country` has a high cardinality: 151 distinct values	High cardinality
`srch_visitor_loc_region` has a high cardinality: 599 distinct values	High cardinality
`srch_visitor_loc_city` has a high cardinality: 5092 distinct values	High cardinality
`srch_posa_country` has a high cardinality: 67 distinct values	High cardinality
`srch_ci` has a high cardinality: 385 distinct values	High cardinality
`srch_co` has a high cardinality: 376 distinct values	High cardinality
`srch_currency` has a high cardinality: 51 distinct values	High cardinality
`srch_hcom_destination_id` is highly correlated with `srch_dest_longitude` and 2 other fields	High correlation
`srch_dest_longitude` is highly correlated with `srch_hcom_destination_id` and 1 other fields	High correlation
`srch_dest_latitude` is highly correlated with `srch_hcom_destination_id` and 1 other fields	High correlation
`srch_adults_cnt` is highly correlated with `srch_rm_cnt`	High correlation
`srch_rm_cnt` is highly correlated with `srch_adults_cnt`	High correlation
`prop_price_without_discount_local` is highly correlated with `prop_price_with_discount_local`	High correlation
`prop_price_without_discount_usd` is highly correlated with `prop_price_with_discount_usd`	High correlation
`prop_price_with_discount_local` is highly correlated with `prop_price_without_discount_local`	High correlation
`prop_price_with_discount_usd` is highly correlated with `prop_price_without_discount_usd`	High correlation
`prop_market_id` is highly correlated with `srch_hcom_destination_id` and 2 other fields	High correlation
`prop_room_capacity` is highly correlated with `prop_review_count`	High correlation
`prop_review_count` is highly correlated with `prop_room_capacity`	High correlation
`srch_hcom_destination_id` is highly correlated with `srch_dest_longitude` and 1 other fields	High correlation
`srch_dest_longitude` is highly correlated with `srch_hcom_destination_id` and 2 other fields	High correlation
`prop_price_without_discount_local` is highly correlated with `prop_price_without_discount_usd` and 2 other fields	High correlation
`prop_price_without_discount_usd` is highly correlated with `prop_price_without_discount_local` and 3 other fields	High correlation
`prop_price_with_discount_local` is highly correlated with `prop_price_without_discount_local` and 2 other fields	High correlation
`prop_price_with_discount_usd` is highly correlated with `prop_price_without_discount_local` and 3 other fields	High correlation
`prop_starrating` is highly correlated with `prop_price_without_discount_usd` and 2 other fields	High correlation
`prop_market_id` is highly correlated with `srch_hcom_destination_id`	High correlation
`prop_room_capacity` is highly correlated with `srch_dest_longitude` and 1 other fields	High correlation
`prop_review_score` is highly correlated with `prop_starrating`	High correlation
`prop_review_count` is highly correlated with `srch_dest_longitude` and 1 other fields	High correlation
`srch_hcom_destination_id` is highly correlated with `prop_market_id`	High correlation
`prop_price_without_discount_local` is highly correlated with `prop_price_without_discount_usd` and 1 other fields	High correlation
`prop_price_without_discount_usd` is highly correlated with `prop_price_without_discount_local` and 1 other fields	High correlation
`prop_price_with_discount_local` is highly correlated with `prop_price_without_discount_local` and 1 other fields	High correlation
`prop_price_with_discount_usd` is highly correlated with `prop_price_without_discount_usd` and 1 other fields	High correlation
`prop_market_id` is highly correlated with `srch_hcom_destination_id`	High correlation
`prop_room_capacity` is highly correlated with `prop_review_count`	High correlation
`prop_review_count` is highly correlated with `prop_room_capacity`	High correlation
`srch_dest_longitude` is highly correlated with `prop_super_region` and 9 other fields	High correlation
`prop_super_region` is highly correlated with `srch_dest_longitude` and 9 other fields	High correlation
`prop_submarket_id` is highly correlated with `srch_dest_longitude` and 8 other fields	High correlation
`srch_dest_latitude` is highly correlated with `srch_dest_longitude` and 9 other fields	High correlation
`srch_device` is highly correlated with `srch_mobile_bool`	High correlation
`srch_posa_continent` is highly correlated with `srch_dest_longitude` and 7 other fields	High correlation
`prop_room_capacity` is highly correlated with `prop_review_count`	High correlation
`prop_key` is highly correlated with `prop_market_id`	High correlation
`prop_price_with_discount_local` is highly correlated with `srch_posa_country` and 2 other fields	High correlation
`srch_co_day` is highly correlated with `srch_ci_day`	High correlation
`prop_review_score` is highly correlated with `prop_starrating`	High correlation
`prop_starrating` is highly correlated with `prop_review_score`	High correlation
`prop_country` is highly correlated with `srch_dest_longitude` and 9 other fields	High correlation
`prop_price_without_discount_usd` is highly correlated with `prop_price_with_discount_usd`	High correlation
`srch_posa_country` is highly correlated with `srch_dest_longitude` and 10 other fields	High correlation
`srch_hcom_destination_id` is highly correlated with `srch_dest_longitude` and 9 other fields	High correlation
`prop_review_count` is highly correlated with `prop_room_capacity`	High correlation
`srch_rm_cnt` is highly correlated with `srch_adults_cnt`	High correlation
`srch_adults_cnt` is highly correlated with `srch_rm_cnt`	High correlation
`srch_ci_day` is highly correlated with `srch_co_day`	High correlation
`prop_price_without_discount_local` is highly correlated with `prop_price_with_discount_local` and 1 other fields	High correlation
`srch_currency` is highly correlated with `srch_dest_longitude` and 11 other fields	High correlation
`prop_continent` is highly correlated with `srch_dest_longitude` and 9 other fields	High correlation
`prop_market_id` is highly correlated with `srch_dest_longitude` and 9 other fields	High correlation
`srch_mobile_bool` is highly correlated with `srch_device`	High correlation
`prop_price_with_discount_usd` is highly correlated with `prop_price_without_discount_usd`	High correlation
`srch_device` is highly correlated with `srch_mobile_app` and 1 other fields	High correlation
`prop_hostel_bool` is highly correlated with `srch_mobile_app`	High correlation
`srch_posa_continent` is highly correlated with `srch_mobile_app` and 2 other fields	High correlation
`srch_local_date` is highly correlated with `srch_mobile_app`	High correlation
`prop_continent` is highly correlated with `srch_mobile_app` and 4 other fields	High correlation
`srch_visitor_wr_member` is highly correlated with `srch_mobile_app`	High correlation
`srch_mobile_app` is highly correlated with `srch_device` and 15 other fields	High correlation
`prop_imp_drr` is highly correlated with `srch_mobile_app`	High correlation
`prop_super_region` is highly correlated with `prop_continent` and 4 other fields	High correlation
`prop_brand_bool` is highly correlated with `srch_mobile_app`	High correlation
`prop_booking_bool` is highly correlated with `srch_mobile_app`	High correlation
`prop_dotd_bool` is highly correlated with `srch_mobile_app`	High correlation
`prop_travelad_bool` is highly correlated with `srch_mobile_app`	High correlation
`srch_posa_country` is highly correlated with `srch_posa_continent` and 4 other fields	High correlation
`prop_country` is highly correlated with `prop_continent` and 2 other fields	High correlation
`srch_mobile_bool` is highly correlated with `srch_device` and 1 other fields	High correlation
`srch_currency` is highly correlated with `srch_posa_continent` and 4 other fields	High correlation
`srch_visitor_wr_member` has 444878 (52.9%) missing values	Missing
`srch_posa_continent` has 485248 (57.7%) missing values	Missing
`srch_currency` has 134104 (15.9%) missing values	Missing
`prop_price_without_discount_local` is highly skewed (γ1 = 63.25387336)	Skewed
`prop_price_without_discount_usd` is highly skewed (γ1 = 110.1131851)	Skewed
`prop_price_with_discount_local` is highly skewed (γ1 = 51.50835913)	Skewed
`prop_price_with_discount_usd` is highly skewed (γ1 = 92.09231784)	Skewed
`srch_bw` has 68898 (8.2%) zeros	Zeros
`srch_children_cnt` has 760192 (90.4%) zeros	Zeros
`prop_starrating` has 10593 (1.3%) zeros	Zeros

Reproduction

Analysis started	2021-07-06 22:53:05.366356
Analysis finished	2021-07-06 22:58:39.744931
Duration	5 minutes and 34.38 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

srch_id
Real number (ℝ)

Distinct	24013
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17242327.95

Minimum	-2147275208
Maximum	2147265531
Zeros	0
Zeros (%)	0.0%
Negative	413244
Negative (%)	49.1%
Memory size	6.4 MiB

Quantile statistics

Minimum	-2147275208
5-th percentile	-1929852848
Q1	-1034005034
median	31939516
Q3	1081645807
95-th percentile	1926418499
Maximum	2147265531
Range	4294540739
Interquartile range (IQR)	2115650841

Descriptive statistics

Standard deviation	1231757238
Coefficient of variation (CV)	71.43798922
Kurtosis	-1.184776024
Mean	17242327.95
Median Absolute Deviation (MAD)	1057033603
Skewness	-0.02450013705
Sum	1.450278067 × 10¹³
Variance	1.517225894 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
609814100	54	< 0.1%
24565744	54	< 0.1%
902104615	54	< 0.1%
1845009119	54	< 0.1%
-1865249101	54	< 0.1%
-57953106	54	< 0.1%
-1141016491	54	< 0.1%
851728248	54	< 0.1%
893859675	54	< 0.1%
-882816104	54	< 0.1%
Other values (24003)	840575	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2147275208	10	< 0.1%
-2147253334	10	< 0.1%
-2146499282	50	< 0.1%
-2146326674	51	< 0.1%
-2146298391	53	< 0.1%
-2146226629	10	< 0.1%
-2146131015	8	< 0.1%
-2145829444	52	< 0.1%
-2145787551	51	< 0.1%
-2145489459	10	< 0.1%

Value	Count	Frequency (%)
2147265531	10	< 0.1%
2146962474	10	< 0.1%
2146790246	49	< 0.1%
2146730644	10	< 0.1%
2146609180	52	< 0.1%
2146405182	44	< 0.1%
2146360973	10	< 0.1%
2146175240	10	< 0.1%
2146041453	50	< 0.1%
2145971382	10	< 0.1%

prop_key
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	6330
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	818556.8818

Minimum	240746
Maximum	3949856
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	240746
5-th percentile	244333
Q1	255952
median	277742
Q3	478133
95-th percentile	3799382
Maximum	3949856
Range	3709110
Interquartile range (IQR)	222181

Descriptive statistics

Standard deviation	1141255.418
Coefficient of variation (CV)	1.394228604
Kurtosis	1.71624615
Mean	818556.8818
Median Absolute Deviation (MAD)	29007
Skewness	1.871536006
Sum	6.885004716 × 10¹¹
Variance	1.30246393 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
259046	4862	0.6%
241770	4641	0.6%
263319	4615	0.5%
263484	4580	0.5%
252583	4514	0.5%
273268	4465	0.5%
245198	4354	0.5%
552965	4347	0.5%
264752	4324	0.5%
552966	4317	0.5%
Other values (6320)	796096	94.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
240746	1063	0.1%
240754	3015	0.4%
240790	342	< 0.1%
240800	935	0.1%
240804	1	< 0.1%
240830	1	< 0.1%
240834	90	< 0.1%
240886	112	< 0.1%
240898	381	< 0.1%
240919	96	< 0.1%

Value	Count	Frequency (%)
3949856	4	< 0.1%
3949720	1	< 0.1%
3949551	1	< 0.1%
3949418	2	< 0.1%
3949311	1	< 0.1%
3949245	1	< 0.1%
3949134	1	< 0.1%
3949083	1	< 0.1%
3949045	1	< 0.1%
3948884	4	< 0.1%

srch_date_time
Categorical

HIGH CARDINALITY

Distinct	23873
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Memory size	61.0 MiB

2014-09-22 23:33:00	106
2014-09-15 20:19:04	105
2014-09-09 18:00:56	105
2014-09-17 16:24:07	105
2014-09-26 19:52:29	105
Other values (23868)	840589

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	15981185
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	36 ?
Unique (%)	< 0.1%

Sample

1st row	2014-09-13 18:37:32
2nd row	2014-09-13 18:37:32
3rd row	2014-09-13 18:37:32
4th row	2014-09-13 18:37:32
5th row	2014-09-13 18:37:32

Common Values

Value	Count	Frequency (%)
2014-09-22 23:33:00	106	< 0.1%
2014-09-15 20:19:04	105	< 0.1%
2014-09-09 18:00:56	105	< 0.1%
2014-09-17 16:24:07	105	< 0.1%
2014-09-26 19:52:29	105	< 0.1%
2014-09-02 18:38:20	105	< 0.1%
2014-09-18 21:51:58	104	< 0.1%
2014-09-02 17:36:25	103	< 0.1%
2014-09-15 16:25:36	103	< 0.1%
2014-09-14 21:31:53	103	< 0.1%
Other values (23863)	840071	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2014-09-03	39487	2.3%
2014-09-09	38261	2.3%
2014-09-08	37843	2.2%
2014-09-02	37839	2.2%
2014-09-04	37662	2.2%
2014-09-17	37515	2.2%
2014-09-10	36488	2.2%
2014-09-15	35691	2.1%
2014-09-11	35239	2.1%
2014-09-12	34176	2.0%
Other values (20596)	1312029	78.0%

Most occurring characters

Value	Count	Frequency (%)
0	2714716	17.0%
1	2271423	14.2%
2	1907976	11.9%
-	1682230	10.5%
:	1682230	10.5%
4	1449681	9.1%
9	1127189	7.1%
	841115	5.3%
3	645781	4.0%
5	613574	3.8%
Other values (3)	1045270	6.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11775610	73.7%
Dash Punctuation	1682230	10.5%
Other Punctuation	1682230	10.5%
Space Separator	841115	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2714716	23.1%
1	2271423	19.3%
2	1907976	16.2%
4	1449681	12.3%
9	1127189	9.6%
3	645781	5.5%
5	613574	5.2%
6	352576	3.0%
7	347590	3.0%
8	345104	2.9%

Dash Punctuation

Value	Count	Frequency (%)
-	1682230	100.0%

Space Separator

Value	Count	Frequency (%)
	841115	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	1682230	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	15981185	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2714716	17.0%
1	2271423	14.2%
2	1907976	11.9%
-	1682230	10.5%
:	1682230	10.5%
4	1449681	9.1%
9	1127189	7.1%
	841115	5.3%
3	645781	4.0%
5	613574	3.8%
Other values (3)	1045270	6.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15981185	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2714716	17.0%
1	2271423	14.2%
2	1907976	11.9%
-	1682230	10.5%
:	1682230	10.5%
4	1449681	9.1%
9	1127189	7.1%
	841115	5.3%
3	645781	4.0%
5	613574	3.8%
Other values (3)	1045270	6.5%

srch_visitor_id
Categorical

HIGH CARDINALITY

Distinct	23101
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Memory size	74.6 MiB

0fac9b35-d7b7-4b71-b275-7da40310ea2e	800
cb732dfb-f598-4e2d-a9cd-c915bd12e36f	681
5e866128-7338-4be3-a7cd-156e510bab06	503
2513167f-f397-492a-86aa-94ec58496028	320
c1838c1f-f797-41c2-82e1-b366d3bb2b76	308
Other values (23096)	838503

Length

Max length	36
Median length	36
Mean length	36
Min length	36

Characters and Unicode

Total characters	30280140
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	33 ?
Unique (%)	< 0.1%

Sample

1st row	9373b009-4e10-495a-afae-204dd1fe4b7c
2nd row	9373b009-4e10-495a-afae-204dd1fe4b7c
3rd row	9373b009-4e10-495a-afae-204dd1fe4b7c
4th row	9373b009-4e10-495a-afae-204dd1fe4b7c
5th row	9373b009-4e10-495a-afae-204dd1fe4b7c

Common Values

Value	Count	Frequency (%)
0fac9b35-d7b7-4b71-b275-7da40310ea2e	800	0.1%
cb732dfb-f598-4e2d-a9cd-c915bd12e36f	681	0.1%
5e866128-7338-4be3-a7cd-156e510bab06	503	0.1%
2513167f-f397-492a-86aa-94ec58496028	320	< 0.1%
c1838c1f-f797-41c2-82e1-b366d3bb2b76	308	< 0.1%
8d0876e7-9070-4ffe-825f-51cd225c68eb	285	< 0.1%
fa32fabe-9de9-4136-a615-b630792bb9db	271	< 0.1%
f8acb1f2-b629-4a0e-8091-f7f8b01d6c9a	261	< 0.1%
76638035-90fd-48ac-8c3a-b27c7ee5f705	259	< 0.1%
e48f2ac3-b53d-45d8-a35e-10aec811af6b	224	< 0.1%
Other values (23091)	837203	99.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0fac9b35-d7b7-4b71-b275-7da40310ea2e	800	0.1%
cb732dfb-f598-4e2d-a9cd-c915bd12e36f	681	0.1%
5e866128-7338-4be3-a7cd-156e510bab06	503	0.1%
2513167f-f397-492a-86aa-94ec58496028	320	< 0.1%
c1838c1f-f797-41c2-82e1-b366d3bb2b76	308	< 0.1%
8d0876e7-9070-4ffe-825f-51cd225c68eb	285	< 0.1%
fa32fabe-9de9-4136-a615-b630792bb9db	271	< 0.1%
f8acb1f2-b629-4a0e-8091-f7f8b01d6c9a	261	< 0.1%
76638035-90fd-48ac-8c3a-b27c7ee5f705	259	< 0.1%
e48f2ac3-b53d-45d8-a35e-10aec811af6b	224	< 0.1%
Other values (23091)	837203	99.5%

Most occurring characters

Value	Count	Frequency (%)
-	3364460	11.1%
4	2403151	7.9%
9	1792973	5.9%
8	1789376	5.9%
b	1786075	5.9%
a	1773699	5.9%
6	1590630	5.3%
0	1587671	5.2%
c	1585333	5.2%
7	1583028	5.2%
Other values (7)	11023744	36.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	17051389	56.3%
Lowercase Letter	9864291	32.6%
Dash Punctuation	3364460	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	2403151	14.1%
9	1792973	10.5%
8	1789376	10.5%
6	1590630	9.3%
0	1587671	9.3%
7	1583028	9.3%
3	1579839	9.3%
2	1579084	9.3%
5	1574243	9.2%
1	1571394	9.2%

Lowercase Letter

Value	Count	Frequency (%)
b	1786075	18.1%
a	1773699	18.0%
c	1585333	16.1%
f	1582974	16.0%
e	1570692	15.9%
d	1565518	15.9%

Dash Punctuation

Value	Count	Frequency (%)
-	3364460	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	20415849	67.4%
Latin	9864291	32.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	3364460	16.5%
4	2403151	11.8%
9	1792973	8.8%
8	1789376	8.8%
6	1590630	7.8%
0	1587671	7.8%
7	1583028	7.8%
3	1579839	7.7%
2	1579084	7.7%
5	1574243	7.7%

Latin

Value	Count	Frequency (%)
b	1786075	18.1%
a	1773699	18.0%
c	1585333	16.1%
f	1582974	16.0%
e	1570692	15.9%
d	1565518	15.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	30280140	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	3364460	11.1%
4	2403151	7.9%
9	1792973	5.9%
8	1789376	5.9%
b	1786075	5.9%
a	1773699	5.9%
6	1590630	5.3%
0	1587671	5.2%
c	1585333	5.2%
7	1583028	5.2%
Other values (7)	11023744	36.4%

srch_visitor_visit_nbr
Real number (ℝ_≥0)

Distinct	267
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.32597683

Minimum	1
Maximum	1082
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	10
95-th percentile	51
Maximum	1082
Range	1081
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	31.78893561
Coefficient of variation (CV)	2.579019582
Kurtosis	192.6232622
Mean	12.32597683
Median Absolute Deviation (MAD)	2
Skewness	10.43091904
Sum	10367564
Variance	1010.536427
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	240336	28.6%
2	111575	13.3%
3	73442	8.7%
4	51948	6.2%
5	41687	5.0%
6	30522	3.6%
7	24148	2.9%
8	23426	2.8%
9	18830	2.2%
11	15188	1.8%
Other values (257)	210013	25.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	240336	28.6%
2	111575	13.3%
3	73442	8.7%
4	51948	6.2%
5	41687	5.0%
6	30522	3.6%
7	24148	2.9%
8	23426	2.8%
9	18830	2.2%
10	14942	1.8%

Value	Count	Frequency (%)
1082	52	< 0.1%
832	50	< 0.1%
725	10	< 0.1%
720	50	< 0.1%
603	49	< 0.1%
593	49	< 0.1%
586	50	< 0.1%
568	49	< 0.1%
518	52	< 0.1%
497	52	< 0.1%

srch_visitor_loc_country
Categorical

HIGH CARDINALITY

Distinct	151
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	59.2 MiB

UNITED STATES OF AMERICA	463183
UNITED KINGDOM	51295
SWEDEN	31177
FRANCE	24430
JAPAN	23331
Other values (146)	247699

Length

Max length	24
Median length	24
Mean length	16.85426725
Min length	3

Characters and Unicode

Total characters	14176377
Distinct characters	29
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TWN
2nd row	TWN
3rd row	TWN
4th row	TWN
5th row	TWN

Common Values

Value	Count	Frequency (%)
UNITED STATES OF AMERICA	463183	55.1%
UNITED KINGDOM	51295	6.1%
SWEDEN	31177	3.7%
FRANCE	24430	2.9%
JAPAN	23331	2.8%
NORWAY	22803	2.7%
SOUTH KOREA	21973	2.6%
CANADA	21272	2.5%
HONG KONG	17774	2.1%
BRAZIL	15633	1.9%
Other values (141)	148244	17.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
united	515730	22.0%
of	463426	19.7%
states	463183	19.7%
america	463183	19.7%
kingdom	51295	2.2%
sweden	31177	1.3%
france	24430	1.0%
japan	23331	1.0%
south	23100	1.0%
norway	22803	1.0%
Other values (168)	265057	11.3%

Most occurring characters

Value	Count	Frequency (%)
A	1752399	12.4%
E	1642867	11.6%
T	1515444	10.7%
	1505600	10.6%
I	1158174	8.2%
S	1036417	7.3%
N	843327	5.9%
D	668867	4.7%
O	651174	4.6%
R	633986	4.5%
Other values (19)	2768122	19.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	12665667	89.3%
Space Separator	1505600	10.6%
Other Punctuation	5110	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1752399	13.8%
E	1642867	13.0%
T	1515444	12.0%
I	1158174	9.1%
S	1036417	8.2%
N	843327	6.7%
D	668867	5.3%
O	651174	5.1%
R	633986	5.0%
U	564878	4.5%
Other values (16)	2198134	17.4%

Other Punctuation

Value	Count	Frequency (%)
&	4547	89.0%
'	563	11.0%

Space Separator

Value	Count	Frequency (%)
	1505600	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12665667	89.3%
Common	1510710	10.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1752399	13.8%
E	1642867	13.0%
T	1515444	12.0%
I	1158174	9.1%
S	1036417	8.2%
N	843327	6.7%
D	668867	5.3%
O	651174	5.1%
R	633986	5.0%
U	564878	4.5%
Other values (16)	2198134	17.4%

Common

Value	Count	Frequency (%)
	1505600	99.7%
&	4547	0.3%
'	563	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14176377	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1752399	12.4%
E	1642867	11.6%
T	1515444	10.7%
	1505600	10.6%
I	1158174	8.2%
S	1036417	7.3%
N	843327	5.9%
D	668867	4.7%
O	651174	4.6%
R	633986	4.5%
Other values (19)	2768122	19.5%

srch_visitor_loc_region
Categorical

HIGH CARDINALITY

Distinct	599
Distinct (%)	0.1%
Missing	123
Missing (%)	< 0.1%
Memory size	47.5 MiB

CA	115310
NY	45051
FL	34241
IL	29272
11	24518
Other values (594)	592600

Length

Max length	9
Median length	2
Mean length	2.217154265
Min length	1

Characters and Unicode

Total characters	1864609
Distinct characters	38
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TPE
2nd row	TPE
3rd row	TPE
4th row	TPE
5th row	TPE

Common Values

Value	Count	Frequency (%)
CA	115310	13.7%
NY	45051	5.4%
FL	34241	4.1%
IL	29272	3.5%
11	24518	2.9%
TX	22965	2.7%
NO REGION	21151	2.5%
AB	17923	2.1%
MA	17496	2.1%
AZ	16596	2.0%
Other values (589)	496469	59.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	115310	13.4%
ny	45051	5.2%
fl	34241	4.0%
il	29272	3.4%
11	24518	2.8%
tx	22965	2.7%
region	21151	2.5%
no	21151	2.5%
ab	17923	2.1%
ma	17496	2.0%
Other values (590)	513065	59.5%

Most occurring characters

Value	Count	Frequency (%)
A	241435	12.9%
N	175429	9.4%
C	166421	8.9%
1	97987	5.3%
O	92296	4.9%
I	91884	4.9%
L	91790	4.9%
M	73355	3.9%
T	64037	3.4%
Y	53386	2.9%
Other values (28)	716589	38.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1607962	86.2%
Decimal Number	235315	12.6%
Space Separator	21151	1.1%
Other Punctuation	181	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	241435	15.0%
N	175429	10.9%
C	166421	10.3%
O	92296	5.7%
I	91884	5.7%
L	91790	5.7%
M	73355	4.6%
T	64037	4.0%
Y	53386	3.3%
R	47126	2.9%
Other values (16)	510803	31.8%

Decimal Number

Value	Count	Frequency (%)
1	97987	41.6%
0	31648	13.4%
3	30802	13.1%
8	19199	8.2%
2	18305	7.8%
4	17625	7.5%
7	6495	2.8%
6	6272	2.7%
5	4146	1.8%
9	2836	1.2%

Space Separator

Value	Count	Frequency (%)
	21151	100.0%

Other Punctuation

Value	Count	Frequency (%)
?	181	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1607962	86.2%
Common	256647	13.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	241435	15.0%
N	175429	10.9%
C	166421	10.3%
O	92296	5.7%
I	91884	5.7%
L	91790	5.7%
M	73355	4.6%
T	64037	4.0%
Y	53386	3.3%
R	47126	2.9%
Other values (16)	510803	31.8%

Common

Value	Count	Frequency (%)
1	97987	38.2%
0	31648	12.3%
3	30802	12.0%
	21151	8.2%
8	19199	7.5%
2	18305	7.1%
4	17625	6.9%
7	6495	2.5%
6	6272	2.4%
5	4146	1.6%
Other values (2)	3017	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1864609	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	241435	12.9%
N	175429	9.4%
C	166421	8.9%
1	97987	5.3%
O	92296	4.9%
I	91884	4.9%
L	91790	4.9%
M	73355	3.9%
T	64037	3.4%
Y	53386	2.9%
Other values (28)	716589	38.4%

srch_visitor_loc_city
Categorical

HIGH CARDINALITY

Distinct	5092
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	52.5 MiB

NEW YORK	21172
SEOUL	16711
LOS ANGELES	14358
HONG KONG	13451
LAS VEGAS	10850
Other values (5087)	764573

Length

Max length	26
Median length	8
Mean length	8.473692658
Min length	1

Characters and Unicode

Total characters	7127350
Distinct characters	31
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	TAIPEI
2nd row	TAIPEI
3rd row	TAIPEI
4th row	TAIPEI
5th row	TAIPEI

Common Values

Value	Count	Frequency (%)
NEW YORK	21172	2.5%
SEOUL	16711	2.0%
LOS ANGELES	14358	1.7%
HONG KONG	13451	1.6%
LAS VEGAS	10850	1.3%
CHICAGO	10661	1.3%
STOCKHOLM	8497	1.0%
TOKYO	8285	1.0%
WASHINGTON	7095	0.8%
SAN FRANCISCO	6746	0.8%
Other values (5082)	723289	86.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
new	23820	2.2%
san	22546	2.1%
york	22196	2.0%
city	19071	1.8%
seoul	16711	1.5%
los	15207	1.4%
angeles	14460	1.3%
hong	13451	1.2%
kong	13451	1.2%
las	11541	1.1%
Other values (5006)	916536	84.2%

Most occurring characters

Value	Count	Frequency (%)
A	749848	10.5%
O	638370	9.0%
E	617265	8.7%
N	585903	8.2%
L	467029	6.6%
S	448118	6.3%
R	429330	6.0%
I	425839	6.0%
T	354416	5.0%
	247875	3.5%
Other values (21)	2163357	30.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	6866306	96.3%
Space Separator	247875	3.5%
Dash Punctuation	12395	0.2%
Other Punctuation	774	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	749848	10.9%
O	638370	9.3%
E	617265	9.0%
N	585903	8.5%
L	467029	6.8%
S	448118	6.5%
R	429330	6.3%
I	425839	6.2%
T	354416	5.2%
H	234899	3.4%
Other values (16)	1915289	27.9%

Other Punctuation

Value	Count	Frequency (%)
'	416	53.7%
?	234	30.2%
.	124	16.0%

Space Separator

Value	Count	Frequency (%)
	247875	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	12395	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6866306	96.3%
Common	261044	3.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	749848	10.9%
O	638370	9.3%
E	617265	9.0%
N	585903	8.5%
L	467029	6.8%
S	448118	6.5%
R	429330	6.3%
I	425839	6.2%
T	354416	5.2%
H	234899	3.4%
Other values (16)	1915289	27.9%

Common

Value	Count	Frequency (%)
	247875	95.0%
-	12395	4.7%
'	416	0.2%
?	234	0.1%
.	124	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7127350	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	749848	10.5%
O	638370	9.0%
E	617265	8.7%
N	585903	8.2%
L	467029	6.6%
S	448118	6.3%
R	429330	6.0%
I	425839	6.0%
T	354416	5.0%
	247875	3.5%
Other values (21)	2163357	30.4%

srch_visitor_wr_member
Categorical

HIGH CORRELATION
MISSING

Distinct	9
Distinct (%)	< 0.1%
Missing	444878
Missing (%)	52.9%
Memory size	50.9 MiB

Not Signed In\|Returning Visitor\|Not FC Member	186401
Not Signed In\|New Visitor\|Not FC Member	90491
Signed In\|WR Member\|Not FC Member	64361
Signed in - Persistent\|WR Member\|Not FC Member	49429
Signed in - Persistent\|WR Member\|Remembered FC Member	3411
Other values (4)	2144

Length

Max length	57
Median length	45
Mean length	41.82906442
Min length	29

Characters and Unicode

Total characters	16574223
Distinct characters	26
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Signed in - Persistent\|WR Member\|Remembered FC Member
2nd row	Signed in - Persistent\|WR Member\|Remembered FC Member
3rd row	Signed in - Persistent\|WR Member\|Remembered FC Member
4th row	Signed in - Persistent\|WR Member\|Remembered FC Member
5th row	Signed in - Persistent\|WR Member\|Remembered FC Member

Common Values

Value	Count	Frequency (%)
Not Signed In\|Returning Visitor\|Not FC Member	186401	22.2%
Not Signed In\|New Visitor\|Not FC Member	90491	10.8%
Signed In\|WR Member\|Not FC Member	64361	7.7%
Signed in - Persistent\|WR Member\|Not FC Member	49429	5.9%
Signed in - Persistent\|WR Member\|Remembered FC Member	3411	0.4%
Signed In\|WR Member\|FC Member	1077	0.1%
Signed In\|Not WR Member\|Not FC Member	540	0.1%
Signed in - Persistent\|Not WR Member\|Not FC Member	379	< 0.1%
Signed in - Persistent\|Not WR Member\|Remembered FC Member	148	< 0.1%
(Missing)	444878	52.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
signed	396237	16.8%
member	396237	16.8%
fc	395160	16.7%
visitor\|not	276892	11.7%
not	276892	11.7%
in\|returning	186401	7.9%
member\|not	114709	4.9%
in\|new	90491	3.8%
in\|wr	65438	2.8%
	53367	2.3%
Other values (7)	112977	4.8%

Most occurring characters

Value	Count	Frequency (%)
	1968564	11.9%
e	1825263	11.0%
i	1243156	7.5%
t	1239587	7.5%
n	1218643	7.4%
r	1035801	6.2%
o	946452	5.7%
\|	792474	4.8%
N	760051	4.6%
g	582638	3.5%
Other values (16)	4961594	29.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	10193695	61.5%
Uppercase Letter	3566123	21.5%
Space Separator	1968564	11.9%
Math Symbol	792474	4.8%
Dash Punctuation	53367	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1825263	17.9%
i	1243156	12.2%
t	1239587	12.2%
n	1218643	12.0%
r	1035801	10.2%
o	946452	9.3%
g	582638	5.7%
m	522700	5.1%
b	519141	5.1%
d	399796	3.9%
Other values (3)	660518	6.5%

Uppercase Letter

Value	Count	Frequency (%)
N	760051	21.3%
M	515582	14.5%
S	396237	11.1%
F	396237	11.1%
C	396237	11.1%
I	342870	9.6%
R	309305	8.7%
V	276892	7.8%
W	119345	3.3%
P	53367	1.5%

Space Separator

Value	Count	Frequency (%)
	1968564	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	53367	100.0%

Math Symbol

Value	Count	Frequency (%)
\|	792474	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	13759818	83.0%
Common	2814405	17.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1825263	13.3%
i	1243156	9.0%
t	1239587	9.0%
n	1218643	8.9%
r	1035801	7.5%
o	946452	6.9%
N	760051	5.5%
g	582638	4.2%
m	522700	3.8%
b	519141	3.8%
Other values (13)	3866386	28.1%

Common

Value	Count	Frequency (%)
	1968564	69.9%
\|	792474	28.2%
-	53367	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16574223	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1968564	11.9%
e	1825263	11.0%
i	1243156	7.5%
t	1239587	7.5%
n	1218643	7.4%
r	1035801	6.2%
o	946452	5.7%
\|	792474	4.8%
N	760051	4.6%
g	582638	3.5%
Other values (16)	4961594	29.9%

srch_posa_continent
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	485248
Missing (%)	57.7%
Memory size	36.0 MiB

EUROPE	207181
ASIA	110575
LATAM	32440
OCEANIA	5671

Length

Max length	7
Median length	6
Mean length	5.303338045
Min length	4

Characters and Unicode

Total characters	1887283
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ASIA
2nd row	ASIA
3rd row	ASIA
4th row	ASIA
5th row	ASIA

Common Values

Value	Count	Frequency (%)
EUROPE	207181	24.6%
ASIA	110575	13.1%
LATAM	32440	3.9%
OCEANIA	5671	0.7%
(Missing)	485248	57.7%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
europe	207181	58.2%
asia	110575	31.1%
latam	32440	9.1%
oceania	5671	1.6%

Most occurring characters

Value	Count	Frequency (%)
E	420033	22.3%
A	297372	15.8%
O	212852	11.3%
U	207181	11.0%
R	207181	11.0%
P	207181	11.0%
I	116246	6.2%
S	110575	5.9%
L	32440	1.7%
T	32440	1.7%
Other values (3)	43782	2.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1887283	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	420033	22.3%
A	297372	15.8%
O	212852	11.3%
U	207181	11.0%
R	207181	11.0%
P	207181	11.0%
I	116246	6.2%
S	110575	5.9%
L	32440	1.7%
T	32440	1.7%
Other values (3)	43782	2.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1887283	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	420033	22.3%
A	297372	15.8%
O	212852	11.3%
U	207181	11.0%
R	207181	11.0%
P	207181	11.0%
I	116246	6.2%
S	110575	5.9%
L	32440	1.7%
T	32440	1.7%
Other values (3)	43782	2.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1887283	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	420033	22.3%
A	297372	15.8%
O	212852	11.3%
U	207181	11.0%
R	207181	11.0%
P	207181	11.0%
I	116246	6.2%
S	110575	5.9%
L	32440	1.7%
T	32440	1.7%
Other values (3)	43782	2.3%

srch_posa_country
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	67
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	49.7 MiB

US	463532
UNITED KINGDOM	51033
SWEDEN	32530
FRANCE	29798
JAPAN	23125
Other values (62)	241097

Length

Max length	25
Median length	2
Mean length	4.992647854
Min length	2

Characters and Unicode

Total characters	4199391
Distinct characters	28
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TAIWAN, REPUBLIC OF CHINA
2nd row	TAIWAN, REPUBLIC OF CHINA
3rd row	TAIWAN, REPUBLIC OF CHINA
4th row	TAIWAN, REPUBLIC OF CHINA
5th row	TAIWAN, REPUBLIC OF CHINA

Common Values

Value	Count	Frequency (%)
US	463532	55.1%
UNITED KINGDOM	51033	6.1%
SWEDEN	32530	3.9%
FRANCE	29798	3.5%
JAPAN	23125	2.7%
SOUTH KOREA	22901	2.7%
NORWAY	22734	2.7%
CANADA	21716	2.6%
EMEA	18278	2.2%
HONG KONG	16671	2.0%
Other values (57)	138797	16.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
us	463532	46.5%
kingdom	51033	5.1%
united	51033	5.1%
sweden	32530	3.3%
france	29798	3.0%
south	24022	2.4%
japan	23125	2.3%
korea	22901	2.3%
china	22854	2.3%
norway	22734	2.3%
Other values (68)	253106	25.4%

Most occurring characters

Value	Count	Frequency (%)
S	572527	13.6%
U	570778	13.6%
A	402728	9.6%
N	381830	9.1%
E	289807	6.9%
I	252941	6.0%
D	198646	4.7%
O	191188	4.6%
R	168528	4.0%
	155553	3.7%
Other values (18)	1014865	24.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4023471	95.8%
Space Separator	155553	3.7%
Other Punctuation	20367	0.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	572527	14.2%
U	570778	14.2%
A	402728	10.0%
N	381830	9.5%
E	289807	7.2%
I	252941	6.3%
D	198646	4.9%
O	191188	4.8%
R	168528	4.2%
T	113918	2.8%
Other values (15)	880580	21.9%

Other Punctuation

Value	Count	Frequency (%)
,	16430	80.7%
&	3937	19.3%

Space Separator

Value	Count	Frequency (%)
	155553	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4023471	95.8%
Common	175920	4.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	572527	14.2%
U	570778	14.2%
A	402728	10.0%
N	381830	9.5%
E	289807	7.2%
I	252941	6.3%
D	198646	4.9%
O	191188	4.8%
R	168528	4.2%
T	113918	2.8%
Other values (15)	880580	21.9%

Common

Value	Count	Frequency (%)
	155553	88.4%
,	16430	9.3%
&	3937	2.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4199391	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	572527	13.6%
U	570778	13.6%
A	402728	9.6%
N	381830	9.1%
E	289807	6.9%
I	252941	6.0%
D	198646	4.7%
O	191188	4.6%
R	168528	4.0%
	155553	3.7%
Other values (18)	1014865	24.2%

srch_hcom_destination_id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1194308.584

Minimum	504261
Maximum	1506246
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	504261
5-th percentile	504261
Q1	726784
median	1497539
Q3	1504033
95-th percentile	1506246
Maximum	1506246
Range	1001985
Interquartile range (IQR)	777249

Descriptive statistics

Standard deviation	423726.7211
Coefficient of variation (CV)	0.3547883075
Kurtosis	-1.397723401
Mean	1194308.584
Median Absolute Deviation (MAD)	8707
Skewness	-0.7206645034
Sum	1.004550865 × 10¹²
Variance	1.795443342 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1504033	229512	27.3%
1506246	188330	22.4%
549499	108661	12.9%
1497539	92281	11.0%
504261	65033	7.7%
1404711	44181	5.3%
726784	39407	4.7%
728660	31007	3.7%
759818	26789	3.2%
712491	15914	1.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
504261	65033	7.7%
549499	108661	12.9%
712491	15914	1.9%
726784	39407	4.7%
728660	31007	3.7%
759818	26789	3.2%
1404711	44181	5.3%
1497539	92281	11.0%
1504033	229512	27.3%
1506246	188330	22.4%

Value	Count	Frequency (%)
1506246	188330	22.4%
1504033	229512	27.3%
1497539	92281	11.0%
1404711	44181	5.3%
759818	26789	3.2%
728660	31007	3.7%
726784	39407	4.7%
712491	15914	1.9%
549499	108661	12.9%
504261	65033	7.7%

srch_dest_longitude
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-45.89280311

Minimum	-115.1728745
Maximum	139.7599945
Zeros	0
Zeros (%)	0.0%
Negative	662965
Negative (%)	78.8%
Memory size	6.4 MiB

Quantile statistics

Minimum	-115.1728745
5-th percentile	-115.1728745
Q1	-115.1728745
median	-73.98647308
Q3	-0.127803996
95-th percentile	135.4981537
Maximum	139.7599945
Range	254.932869
Interquartile range (IQR)	115.0450705

Descriptive statistics

Standard deviation	77.70605067
Coefficient of variation (CV)	-1.693207767
Kurtosis	0.6220493695
Mean	-45.89280311
Median Absolute Deviation (MAD)	41.18640142
Skewness	1.285501783
Sum	-38601125.08
Variance	6038.23031
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-115.1728745	229512	27.3%
-73.98647308	188330	22.4%
-0.127803996	108661	12.9%
-87.62812805	92281	11.0%
2.34375	65033	7.7%
-81.37904358	44181	5.3%
139.7599945	39407	4.7%
135.4981537	31007	3.7%
126.9825745	26789	3.2%
12.5009203	15914	1.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-115.1728745	229512	27.3%
-87.62812805	92281	11.0%
-81.37904358	44181	5.3%
-73.98647308	188330	22.4%
-0.127803996	108661	12.9%
2.34375	65033	7.7%
12.5009203	15914	1.9%
126.9825745	26789	3.2%
135.4981537	31007	3.7%
139.7599945	39407	4.7%

Value	Count	Frequency (%)
139.7599945	39407	4.7%
135.4981537	31007	3.7%
126.9825745	26789	3.2%
12.5009203	15914	1.9%
2.34375	65033	7.7%
-0.127803996	108661	12.9%
-73.98647308	188330	22.4%
-81.37904358	44181	5.3%
-87.62812805	92281	11.0%
-115.1728745	229512	27.3%

srch_dest_latitude
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.4459316

Minimum	28.54129028
Maximum	51.50753784
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	28.54129028
5-th percentile	28.54129028
Q1	36.11466599
median	40.75667954
Q3	41.88077927
95-th percentile	51.50753784
Maximum	51.50753784
Range	22.96624756
Interquartile range (IQR)	5.766113281

Descriptive statistics

Standard deviation	6.056536844
Coefficient of variation (CV)	0.1497440312
Kurtosis	-0.3688261375
Mean	40.4459316
Median Absolute Deviation (MAD)	4.64201355
Skewness	0.4398438668
Sum	34019679.76
Variance	36.68163854
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
36.11466599	229512	27.3%
40.75667954	188330	22.4%
51.50753784	108661	12.9%
41.88077927	92281	11.0%
48.86272049	65033	7.7%
28.54129028	44181	5.3%
35.67499924	39407	4.7%
34.70189667	31007	3.7%
37.56599426	26789	3.2%
41.89332962	15914	1.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
28.54129028	44181	5.3%
34.70189667	31007	3.7%
35.67499924	39407	4.7%
36.11466599	229512	27.3%
37.56599426	26789	3.2%
40.75667954	188330	22.4%
41.88077927	92281	11.0%
41.89332962	15914	1.9%
48.86272049	65033	7.7%
51.50753784	108661	12.9%

Value	Count	Frequency (%)
51.50753784	108661	12.9%
48.86272049	65033	7.7%
41.89332962	15914	1.9%
41.88077927	92281	11.0%
40.75667954	188330	22.4%
37.56599426	26789	3.2%
36.11466599	229512	27.3%
35.67499924	39407	4.7%
34.70189667	31007	3.7%
28.54129028	44181	5.3%

srch_ci
Categorical

HIGH CARDINALITY

Distinct	385
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.7 MiB

2014-09-26	23604
2014-09-27	20095
2014-09-25	17645
2014-09-12	17519
2014-10-03	17397
Other values (380)	744855

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	8411150
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	2015-02-25
2nd row	2015-02-25
3rd row	2015-02-25
4th row	2015-02-25
5th row	2015-02-25

Common Values

Value	Count	Frequency (%)
2014-09-26	23604	2.8%
2014-09-27	20095	2.4%
2014-09-25	17645	2.1%
2014-09-12	17519	2.1%
2014-10-03	17397	2.1%
2014-09-19	17047	2.0%
2014-09-17	16773	2.0%
2014-09-18	16121	1.9%
2014-09-15	16090	1.9%
2014-09-13	15145	1.8%
Other values (375)	663679	78.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2014-09-26	23604	2.8%
2014-09-27	20095	2.4%
2014-09-25	17645	2.1%
2014-09-12	17519	2.1%
2014-10-03	17397	2.1%
2014-09-19	17047	2.0%
2014-09-17	16773	2.0%
2014-09-18	16121	1.9%
2014-09-15	16090	1.9%
2014-09-13	15145	1.8%
Other values (375)	663679	78.9%

Most occurring characters

Value	Count	Frequency (%)
0	1859900	22.1%
1	1712432	20.4%
-	1682230	20.0%
2	1270744	15.1%
4	875706	10.4%
9	480273	5.7%
5	141312	1.7%
3	125449	1.5%
7	91265	1.1%
6	88574	1.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6728920	80.0%
Dash Punctuation	1682230	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1859900	27.6%
1	1712432	25.4%
2	1270744	18.9%
4	875706	13.0%
9	480273	7.1%
5	141312	2.1%
3	125449	1.9%
7	91265	1.4%
6	88574	1.3%
8	83265	1.2%

Dash Punctuation

Value	Count	Frequency (%)
-	1682230	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	8411150	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1859900	22.1%
1	1712432	20.4%
-	1682230	20.0%
2	1270744	15.1%
4	875706	10.4%
9	480273	5.7%
5	141312	1.7%
3	125449	1.5%
7	91265	1.1%
6	88574	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8411150	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1859900	22.1%
1	1712432	20.4%
-	1682230	20.0%
2	1270744	15.1%
4	875706	10.4%
9	480273	5.7%
5	141312	1.7%
3	125449	1.5%
7	91265	1.1%
6	88574	1.1%

srch_co
Categorical

HIGH CARDINALITY

Distinct	376
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.7 MiB

2014-09-28	28497
2014-10-05	20994
2014-09-14	19867
2014-09-21	19524
2014-09-19	18294
Other values (371)	733939

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	8411150
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2015-02-28
2nd row	2015-02-28
3rd row	2015-02-28
4th row	2015-02-28
5th row	2015-02-28

Common Values

Value	Count	Frequency (%)
2014-09-28	28497	3.4%
2014-10-05	20994	2.5%
2014-09-14	19867	2.4%
2014-09-21	19524	2.3%
2014-09-19	18294	2.2%
2014-09-26	15917	1.9%
2014-09-18	15393	1.8%
2014-09-29	15303	1.8%
2014-09-27	14002	1.7%
2014-10-03	13708	1.6%
Other values (366)	659616	78.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2014-09-28	28497	3.4%
2014-10-05	20994	2.5%
2014-09-14	19867	2.4%
2014-09-21	19524	2.3%
2014-09-19	18294	2.2%
2014-09-26	15917	1.9%
2014-09-18	15393	1.8%
2014-09-29	15303	1.8%
2014-09-27	14002	1.7%
2014-10-03	13708	1.6%
Other values (366)	659616	78.4%

Most occurring characters

Value	Count	Frequency (%)
0	1851353	22.0%
1	1753743	20.9%
-	1682230	20.0%
2	1265309	15.0%
4	869049	10.3%
9	461090	5.5%
5	151801	1.8%
3	118517	1.4%
8	88405	1.1%
7	85033	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6728920	80.0%
Dash Punctuation	1682230	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1851353	27.5%
1	1753743	26.1%
2	1265309	18.8%
4	869049	12.9%
9	461090	6.9%
5	151801	2.3%
3	118517	1.8%
8	88405	1.3%
7	85033	1.3%
6	84620	1.3%

Dash Punctuation

Value	Count	Frequency (%)
-	1682230	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	8411150	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1851353	22.0%
1	1753743	20.9%
-	1682230	20.0%
2	1265309	15.0%
4	869049	10.3%
9	461090	5.5%
5	151801	1.8%
3	118517	1.4%
8	88405	1.1%
7	85033	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8411150	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1851353	22.0%
1	1753743	20.9%
-	1682230	20.0%
2	1265309	15.0%
4	869049	10.3%
9	461090	5.5%
5	151801	1.8%
3	118517	1.4%
8	88405	1.1%
7	85033	1.0%

srch_ci_day
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.272101912

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.003198942
Coefficient of variation (CV)	0.468902424
Kurtosis	-1.237579205
Mean	4.272101912
Median Absolute Deviation (MAD)	2
Skewness	-0.2313280916
Sum	3593329
Variance	4.012806002
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
6	169500	20.2%
7	129966	15.5%
5	124112	14.8%
4	108793	12.9%
1	105381	12.5%
2	104635	12.4%
3	98728	11.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	105381	12.5%
2	104635	12.4%
3	98728	11.7%
4	108793	12.9%
5	124112	14.8%
6	169500	20.2%
7	129966	15.5%

Value	Count	Frequency (%)
7	129966	15.5%
6	169500	20.2%
5	124112	14.8%
4	108793	12.9%
3	98728	11.7%
2	104635	12.4%
1	105381	12.5%

srch_co_day
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.689650048

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.128168459
Coefficient of variation (CV)	0.5767941217
Kurtosis	-1.390812408
Mean	3.689650048
Median Absolute Deviation (MAD)	2
Skewness	0.1445899203
Sum	3103420
Variance	4.529100988
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	195518	23.2%
6	123436	14.7%
2	120999	14.4%
7	105796	12.6%
5	102095	12.1%
3	98843	11.8%
4	94428	11.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	195518	23.2%
2	120999	14.4%
3	98843	11.8%
4	94428	11.2%
5	102095	12.1%
6	123436	14.7%
7	105796	12.6%

Value	Count	Frequency (%)
7	105796	12.6%
6	123436	14.7%
5	102095	12.1%
4	94428	11.2%
3	98843	11.8%
2	120999	14.4%
1	195518	23.2%

srch_los
Real number (ℝ_≥0)

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.677237952

Minimum	1
Maximum	28
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	7
Maximum	28
Range	27
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.192103099
Coefficient of variation (CV)	0.8187927776
Kurtosis	18.15820755
Mean	2.677237952
Median Absolute Deviation (MAD)	1
Skewness	3.176307195
Sum	2251865
Variance	4.805315997
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
1	279368	33.2%
2	224572	26.7%
3	152235	18.1%
4	78333	9.3%
5	40353	4.8%
6	20690	2.5%
7	17979	2.1%
8	6723	0.8%
10	5526	0.7%
9	4845	0.6%
Other values (17)	10491	1.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	279368	33.2%
2	224572	26.7%
3	152235	18.1%
4	78333	9.3%
5	40353	4.8%
6	20690	2.5%
7	17979	2.1%
8	6723	0.8%
9	4845	0.6%
10	5526	0.7%

Value	Count	Frequency (%)
28	363	< 0.1%
27	5	< 0.1%
25	8	< 0.1%
24	34	< 0.1%
23	94	< 0.1%
22	134	< 0.1%
21	43	< 0.1%
20	337	< 0.1%
19	190	< 0.1%
18	95	< 0.1%

srch_bw
Real number (ℝ_≥0)

ZEROS

Distinct	370
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35.34915677

Minimum	0
Maximum	473
Zeros	68898
Zeros (%)	8.2%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4
median	17
Q3	46
95-th percentile	123
Maximum	473
Range	473
Interquartile range (IQR)	42

Descriptive statistics

Standard deviation	49.50678471
Coefficient of variation (CV)	1.400508222
Kurtosis	11.44619023
Mean	35.34915677
Median Absolute Deviation (MAD)	15
Skewness	2.89395015
Sum	29732706
Variance	2450.921733
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	68898	8.2%
1	55718	6.6%
2	35314	4.2%
3	28591	3.4%
4	25924	3.1%
5	25637	3.0%
6	22257	2.6%
7	20416	2.4%
8	17128	2.0%
9	16471	2.0%
Other values (360)	524761	62.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	68898	8.2%
1	55718	6.6%
2	35314	4.2%
3	28591	3.4%
4	25924	3.1%
5	25637	3.0%
6	22257	2.6%
7	20416	2.4%
8	17128	2.0%
9	16471	2.0%

Value	Count	Frequency (%)
473	50	< 0.1%
468	10	< 0.1%
464	10	< 0.1%
443	10	< 0.1%
433	42	< 0.1%
421	9	< 0.1%
418	50	< 0.1%
416	10	< 0.1%
415	50	< 0.1%
409	48	< 0.1%

srch_adults_cnt
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	16
Distinct (%)	< 0.1%
Missing	18
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.019900202

Minimum	1
Maximum	16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	4
Maximum	16
Range	15
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.02062611
Coefficient of variation (CV)	0.5052854142
Kurtosis	25.4761709
Mean	2.019900202
Median Absolute Deviation (MAD)	0
Skewness	3.580089139
Sum	1698932
Variance	1.041677657
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
2	533366	63.4%
1	200294	23.8%
3	44628	5.3%
4	44508	5.3%
6	6854	0.8%
5	6046	0.7%
8	2165	0.3%
7	1085	0.1%
10	680	0.1%
9	559	0.1%
Other values (6)	912	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	200294	23.8%
2	533366	63.4%
3	44628	5.3%
4	44508	5.3%
5	6046	0.7%
6	6854	0.8%
7	1085	0.1%
8	2165	0.3%
9	559	0.1%
10	680	0.1%

Value	Count	Frequency (%)
16	165	< 0.1%
15	10	< 0.1%
14	113	< 0.1%
13	102	< 0.1%
12	450	0.1%
11	72	< 0.1%
10	680	0.1%
9	559	0.1%
8	2165	0.3%
7	1085	0.1%

srch_children_cnt
Real number (ℝ_≥0)

ZEROS

Distinct	9
Distinct (%)	< 0.1%
Missing	18
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.1614665134

Minimum	0
Maximum	8
Zeros	760192
Zeros (%)	90.4%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	8
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.5460633829
Coefficient of variation (CV)	3.381898646
Kurtosis	17.04005121
Mean	0.1614665134
Median Absolute Deviation (MAD)	0
Skewness	3.857360437
Sum	135809
Variance	0.2981852182
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0	760192	90.4%
1	36644	4.4%
2	35613	4.2%
3	7258	0.9%
4	1023	0.1%
5	196	< 0.1%
6	113	< 0.1%
7	49	< 0.1%
8	9	< 0.1%
(Missing)	18	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	760192	90.4%
1	36644	4.4%
2	35613	4.2%
3	7258	0.9%
4	1023	0.1%
5	196	< 0.1%
6	113	< 0.1%
7	49	< 0.1%
8	9	< 0.1%

Value	Count	Frequency (%)
8	9	< 0.1%
7	49	< 0.1%
6	113	< 0.1%
5	196	< 0.1%
4	1023	0.1%
3	7258	0.9%
2	35613	4.2%
1	36644	4.4%
0	760192	90.4%

srch_rm_cnt
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.113059451

Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	8
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.4476569378
Coefficient of variation (CV)	0.4021860085
Kurtosis	55.3619333
Mean	1.113059451
Median Absolute Deviation (MAD)	0
Skewness	6.177560561
Sum	936211
Variance	0.2003967339
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	770809	91.6%
2	55399	6.6%
3	9300	1.1%
4	3256	0.4%
5	1332	0.2%
6	439	0.1%
8	326	< 0.1%
7	254	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	770809	91.6%
2	55399	6.6%
3	9300	1.1%
4	3256	0.4%
5	1332	0.2%
6	439	0.1%
7	254	< 0.1%
8	326	< 0.1%

Value	Count	Frequency (%)
8	326	< 0.1%
7	254	< 0.1%
6	439	0.1%
5	1332	0.2%
4	3256	0.4%
3	9300	1.1%
2	55399	6.6%
1	770809	91.6%

srch_mobile_bool
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.5 MiB

0	719008
1	122107

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	841115
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	719008	85.5%
1	122107	14.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	719008	85.5%
1	122107	14.5%

Most occurring characters

Value	Count	Frequency (%)
0	719008	85.5%
1	122107	14.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	841115	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	719008	85.5%
1	122107	14.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	841115	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	719008	85.5%
1	122107	14.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	841115	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	719008	85.5%
1	122107	14.5%

srch_mobile_app
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.5 MiB

0	841115

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	841115
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	841115	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	841115	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	841115	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	841115	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	841115	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	841115	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	841115	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	841115	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	841115	100.0%

srch_device
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	51.2 MiB

DESKTOP	718871
TABWEB	106904
WEB	15340

Length

Max length	7
Median length	7
Mean length	6.799951255
Min length	3

Characters and Unicode

Total characters	5719541
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DESKTOP
2nd row	DESKTOP
3rd row	DESKTOP
4th row	DESKTOP
5th row	DESKTOP

Common Values

Value	Count	Frequency (%)
DESKTOP	718871	85.5%
TABWEB	106904	12.7%
WEB	15340	1.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
desktop	718871	85.5%
tabweb	106904	12.7%
web	15340	1.8%

Most occurring characters

Value	Count	Frequency (%)
E	841115	14.7%
T	825775	14.4%
D	718871	12.6%
S	718871	12.6%
K	718871	12.6%
O	718871	12.6%
P	718871	12.6%
B	229148	4.0%
W	122244	2.1%
A	106904	1.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	5719541	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	841115	14.7%
T	825775	14.4%
D	718871	12.6%
S	718871	12.6%
K	718871	12.6%
O	718871	12.6%
P	718871	12.6%
B	229148	4.0%
W	122244	2.1%
A	106904	1.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5719541	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	841115	14.7%
T	825775	14.4%
D	718871	12.6%
S	718871	12.6%
K	718871	12.6%
O	718871	12.6%
P	718871	12.6%
B	229148	4.0%
W	122244	2.1%
A	106904	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5719541	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	841115	14.7%
T	825775	14.4%
D	718871	12.6%
S	718871	12.6%
K	718871	12.6%
O	718871	12.6%
P	718871	12.6%
B	229148	4.0%
W	122244	2.1%
A	106904	1.9%

srch_currency
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	51
Distinct (%)	< 0.1%
Missing	134104
Missing (%)	15.9%
Memory size	44.5 MiB

USD	412926
EUR	53654
GBP	43749
SEK	28876
NOK	20436
Other values (46)	147370

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	2121033
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TWD
2nd row	TWD
3rd row	TWD
4th row	TWD
5th row	TWD

Common Values

Value	Count	Frequency (%)
USD	412926	49.1%
EUR	53654	6.4%
GBP	43749	5.2%
SEK	28876	3.4%
NOK	20436	2.4%
JPY	18138	2.2%
CAD	17762	2.1%
KRW	17761	2.1%
HKD	14999	1.8%
BRL	13302	1.6%
Other values (41)	65408	7.8%
(Missing)	134104	15.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
usd	412926	58.4%
eur	53654	7.6%
gbp	43749	6.2%
sek	28876	4.1%
nok	20436	2.9%
jpy	18138	2.6%
cad	17762	2.5%
krw	17761	2.5%
hkd	14999	2.1%
brl	13302	1.9%
Other values (41)	65408	9.3%

Most occurring characters

Value	Count	Frequency (%)
D	480294	22.6%
U	473947	22.3%
S	449251	21.2%
K	106235	5.0%
R	94897	4.5%
E	82929	3.9%
P	65382	3.1%
B	61799	2.9%
G	48194	2.3%
N	32778	1.5%
Other values (16)	225327	10.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2121033	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
D	480294	22.6%
U	473947	22.3%
S	449251	21.2%
K	106235	5.0%
R	94897	4.5%
E	82929	3.9%
P	65382	3.1%
B	61799	2.9%
G	48194	2.3%
N	32778	1.5%
Other values (16)	225327	10.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2121033	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	480294	22.6%
U	473947	22.3%
S	449251	21.2%
K	106235	5.0%
R	94897	4.5%
E	82929	3.9%
P	65382	3.1%
B	61799	2.9%
G	48194	2.3%
N	32778	1.5%
Other values (16)	225327	10.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2121033	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	480294	22.6%
U	473947	22.3%
S	449251	21.2%
K	106235	5.0%
R	94897	4.5%
E	82929	3.9%
P	65382	3.1%
B	61799	2.9%
G	48194	2.3%
N	32778	1.5%
Other values (16)	225327	10.6%

prop_travelad_bool
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.5 MiB

0	830836
1	10279

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	841115
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	830836	98.8%
1	10279	1.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	830836	98.8%
1	10279	1.2%

Most occurring characters

Value	Count	Frequency (%)
0	830836	98.8%
1	10279	1.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	841115	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	830836	98.8%
1	10279	1.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	841115	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	830836	98.8%
1	10279	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	841115	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	830836	98.8%
1	10279	1.2%

prop_dotd_bool
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.5 MiB

0	837911
1	3204

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	841115
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	837911	99.6%
1	3204	0.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	837911	99.6%
1	3204	0.4%

Most occurring characters

Value	Count	Frequency (%)
0	837911	99.6%
1	3204	0.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	841115	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	837911	99.6%
1	3204	0.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	841115	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	837911	99.6%
1	3204	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	841115	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	837911	99.6%
1	3204	0.4%

prop_price_without_discount_local
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	40511
Distinct (%)	4.8%
Missing	51
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	12045.08004

Minimum	8
Maximum	31954891
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	8
5-th percentile	64
Q1	169
median	339
Q3	665
95-th percentile	17172
Maximum	31954891
Range	31954883
Interquartile range (IQR)	496

Descriptive statistics

Standard deviation	167927.2531
Coefficient of variation (CV)	13.94156391
Kurtosis	6315.146435
Mean	12045.08004
Median Absolute Deviation (MAD)	201
Skewness	63.25387336
Sum	1.01306832 × 10¹⁰
Variance	2.819956234 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
499	10167	1.2%
299	8398	1.0%
199	6631	0.8%
399	6551	0.8%
529	5969	0.7%
279	5653	0.7%
149	5436	0.6%
459	5371	0.6%
359	5334	0.6%
129	4860	0.6%
Other values (40501)	776694	92.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
8	4	< 0.1%
9	1	< 0.1%
10	12	< 0.1%
11	17	< 0.1%
12	17	< 0.1%
13	15	< 0.1%
14	45	< 0.1%
15	59	< 0.1%
16	53	< 0.1%
17	46	< 0.1%

Value	Count	Frequency (%)
31954891	1	< 0.1%
29633273	1	< 0.1%
23249042	1	< 0.1%
19266751	1	< 0.1%
18811139	1	< 0.1%
18050992	1	< 0.1%
17892829	1	< 0.1%
17530272	1	< 0.1%
16831025	2	< 0.1%
16274868	1	< 0.1%

prop_price_without_discount_usd
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	75478
Distinct (%)	9.0%
Missing	51
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	452.7639873

Minimum	0
Maximum	1976732.58
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	0
5-th percentile	57
Q1	144
median	273
Q3	449
95-th percentile	749
Maximum	1976732.58
Range	1976732.58
Interquartile range (IQR)	305

Descriptive statistics

Standard deviation	6864.687807
Coefficient of variation (CV)	15.16173547
Kurtosis	18352.23406
Mean	452.7639873
Median Absolute Deviation (MAD)	144
Skewness	110.1131851
Sum	380803490.2
Variance	47123938.69
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
499	9881	1.2%
299	7975	0.9%
399	6262	0.7%
199	6047	0.7%
529	5847	0.7%
279	5272	0.6%
459	5192	0.6%
359	5112	0.6%
149	4935	0.6%
329	4449	0.5%
Other values (75468)	780092	92.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
0.01	63	< 0.1%
0.02	69	< 0.1%
0.03	58	< 0.1%
0.04	46	< 0.1%
0.05	45	< 0.1%
0.06	35	< 0.1%
0.07	40	< 0.1%
0.08	30	< 0.1%
0.09	23	< 0.1%

Value	Count	Frequency (%)
1976732.58	1	< 0.1%
1347760	2	< 0.1%
1272205	1	< 0.1%
1087117	1	< 0.1%
1032895	1	< 0.1%
952597	1	< 0.1%
870972	1	< 0.1%
816520	1	< 0.1%
769073	1	< 0.1%
739924	1	< 0.1%

prop_price_with_discount_local
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	37770
Distinct (%)	4.5%
Missing	51
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	8519.443857

Minimum	6
Maximum	17621297
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	6
5-th percentile	42
Q1	116
median	235
Q3	466
95-th percentile	12125
Maximum	17621297
Range	17621291
Interquartile range (IQR)	350

Descriptive statistics

Standard deviation	113014.2593
Coefficient of variation (CV)	13.26545033
Kurtosis	3729.459195
Mean	8519.443857
Median Absolute Deviation (MAD)	141
Skewness	51.50835913
Sum	7165397528
Variance	1.27722228 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
199	7129	0.8%
299	6642	0.8%
69	6236	0.7%
159	6023	0.7%
229	5689	0.7%
179	5598	0.7%
99	5271	0.6%
279	5088	0.6%
89	5028	0.6%
149	4940	0.6%
Other values (37760)	783420	93.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	1	< 0.1%
7	3	< 0.1%
8	9	< 0.1%
9	31	< 0.1%
10	37	< 0.1%
11	76	< 0.1%
12	97	< 0.1%
13	111	< 0.1%
14	449	0.1%
15	337	< 0.1%

Value	Count	Frequency (%)
17621297	1	< 0.1%
12305451	1	< 0.1%
11867928	1	< 0.1%
11694717	1	< 0.1%
11441911	1	< 0.1%
11101435	1	< 0.1%
10819774	1	< 0.1%
10462174	1	< 0.1%
10263094	1	< 0.1%
10099350	1	< 0.1%

prop_price_with_discount_usd
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	59865
Distinct (%)	7.1%
Missing	51
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	304.4565213

Minimum	0
Maximum	1087117
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	0
5-th percentile	38.9815
Q1	99.02
median	189
Q3	299
95-th percentile	499
Maximum	1087117
Range	1087117
Interquartile range (IQR)	199.98

Descriptive statistics

Standard deviation	4205.190231
Coefficient of variation (CV)	13.81212074
Kurtosis	12429.72469
Mean	304.4565213
Median Absolute Deviation (MAD)	97.57
Skewness	92.09231784
Sum	256067419.6
Variance	17683624.88
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
299	6399	0.8%
199	6378	0.8%
69	5731	0.7%
159	5335	0.6%
229	5318	0.6%
179	4994	0.6%
279	4821	0.6%
269	4458	0.5%
249	4415	0.5%
99	4350	0.5%
Other values (59855)	788865	93.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4	< 0.1%
0.01	94	< 0.1%
0.02	95	< 0.1%
0.03	75	< 0.1%
0.04	34	< 0.1%
0.05	38	< 0.1%
0.06	47	< 0.1%
0.07	67	< 0.1%
0.08	51	< 0.1%
0.09	49	< 0.1%

Value	Count	Frequency (%)
1087117	1	< 0.1%
745452	1	< 0.1%
656904	1	< 0.1%
636740	1	< 0.1%
585629	1	< 0.1%
524520	1	< 0.1%
523860	1	< 0.1%
497254	1	< 0.1%
485579	1	< 0.1%
418295	1	< 0.1%

prop_imp_drr
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.5 MiB

0	482802
1	358313

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	841115
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	482802	57.4%
1	358313	42.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	482802	57.4%
1	358313	42.6%

Most occurring characters

Value	Count	Frequency (%)
0	482802	57.4%
1	358313	42.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	841115	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	482802	57.4%
1	358313	42.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	841115	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	482802	57.4%
1	358313	42.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	841115	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	482802	57.4%
1	358313	42.6%

prop_booking_bool
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.5 MiB

0	817102
1	24013

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	841115
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	817102	97.1%
1	24013	2.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	817102	97.1%
1	24013	2.9%

Most occurring characters

Value	Count	Frequency (%)
0	817102	97.1%
1	24013	2.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	841115	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	817102	97.1%
1	24013	2.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	841115	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	817102	97.1%
1	24013	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	841115	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	817102	97.1%
1	24013	2.9%

prop_brand_bool
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.5 MiB

1	558600
0	282515

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	841115
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
1	558600	66.4%
0	282515	33.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	558600	66.4%
0	282515	33.6%

Most occurring characters

Value	Count	Frequency (%)
1	558600	66.4%
0	282515	33.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	841115	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	558600	66.4%
0	282515	33.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	841115	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	558600	66.4%
0	282515	33.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	841115	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	558600	66.4%
0	282515	33.6%

prop_starrating
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.595627233

Minimum	0
Maximum	5
Zeros	10593
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	3
median	4
Q3	4
95-th percentile	5
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.8645742241
Coefficient of variation (CV)	0.240451573
Kurtosis	2.460363408
Mean	3.595627233
Median Absolute Deviation (MAD)	0.5
Skewness	-0.9343957152
Sum	3024336
Variance	0.7474885889
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4	300791	35.8%
3	210900	25.1%
3.5	104581	12.4%
5	80056	9.5%
4.5	55581	6.6%
2	37710	4.5%
2.5	35516	4.2%
0	10593	1.3%
1.5	4894	0.6%
1	493	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10593	1.3%
1	493	0.1%
1.5	4894	0.6%
2	37710	4.5%
2.5	35516	4.2%
3	210900	25.1%
3.5	104581	12.4%
4	300791	35.8%
4.5	55581	6.6%
5	80056	9.5%

Value	Count	Frequency (%)
5	80056	9.5%
4.5	55581	6.6%
4	300791	35.8%
3.5	104581	12.4%
3	210900	25.1%
2.5	35516	4.2%
2	37710	4.5%
1.5	4894	0.6%
1	493	0.1%
0	10593	1.3%

prop_super_region
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.9 MiB

AMER	554304
EMEA	189606
APAC	97203
LATAM	2

Length

Max length	5
Median length	4
Mean length	4.000002378
Min length	4

Characters and Unicode

Total characters	3364462
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	APAC
2nd row	APAC
3rd row	APAC
4th row	APAC
5th row	APAC

Common Values

Value	Count	Frequency (%)
AMER	554304	65.9%
EMEA	189606	22.5%
APAC	97203	11.6%
LATAM	2	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
amer	554304	65.9%
emea	189606	22.5%
apac	97203	11.6%
latam	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	938320	27.9%
E	933516	27.7%
M	743912	22.1%
R	554304	16.5%
P	97203	2.9%
C	97203	2.9%
L	2	< 0.1%
T	2	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3364462	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	938320	27.9%
E	933516	27.7%
M	743912	22.1%
R	554304	16.5%
P	97203	2.9%
C	97203	2.9%
L	2	< 0.1%
T	2	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3364462	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	938320	27.9%
E	933516	27.7%
M	743912	22.1%
R	554304	16.5%
P	97203	2.9%
C	97203	2.9%
L	2	< 0.1%
T	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3364462	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	938320	27.9%
E	933516	27.7%
M	743912	22.1%
R	554304	16.5%
P	97203	2.9%
C	97203	2.9%
L	2	< 0.1%
T	2	< 0.1%

prop_continent
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 MiB

NORTHAMERICA	554304
EUROPE	189606
ASIA	97203
LATAM	2

Length

Max length	12
Median length	12
Mean length	9.722934438
Min length	4

Characters and Unicode

Total characters	8178106
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ASIA
2nd row	ASIA
3rd row	ASIA
4th row	ASIA
5th row	ASIA

Common Values

Value	Count	Frequency (%)
NORTHAMERICA	554304	65.9%
EUROPE	189606	22.5%
ASIA	97203	11.6%
LATAM	2	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
northamerica	554304	65.9%
europe	189606	22.5%
asia	97203	11.6%
latam	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	1303018	15.9%
R	1298214	15.9%
E	933516	11.4%
O	743910	9.1%
I	651507	8.0%
T	554306	6.8%
M	554306	6.8%
N	554304	6.8%
H	554304	6.8%
C	554304	6.8%
Other values (4)	476417	5.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	8178106	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1303018	15.9%
R	1298214	15.9%
E	933516	11.4%
O	743910	9.1%
I	651507	8.0%
T	554306	6.8%
M	554306	6.8%
N	554304	6.8%
H	554304	6.8%
C	554304	6.8%
Other values (4)	476417	5.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8178106	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1303018	15.9%
R	1298214	15.9%
E	933516	11.4%
O	743910	9.1%
I	651507	8.0%
T	554306	6.8%
M	554306	6.8%
N	554304	6.8%
H	554304	6.8%
C	554304	6.8%
Other values (4)	476417	5.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8178106	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1303018	15.9%
R	1298214	15.9%
E	933516	11.4%
O	743910	9.1%
I	651507	8.0%
T	554306	6.8%
M	554306	6.8%
N	554304	6.8%
H	554304	6.8%
C	554304	6.8%
Other values (4)	476417	5.8%

prop_country
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	60.9 MiB

UNITED STATES OF AMERICA	554304
UNITED KINGDOM	108661
JAPAN	70414
FRANCE	65031
SOUTH KOREA	26789
Other values (2)	15916

Length

Max length	24
Median length	24
Mean length	18.9523133
Min length	5

Characters and Unicode

Total characters	15941075
Distinct characters	22
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	JAPAN
2nd row	JAPAN
3rd row	JAPAN
4th row	JAPAN
5th row	JAPAN

Common Values

Value	Count	Frequency (%)
UNITED STATES OF AMERICA	554304	65.9%
UNITED KINGDOM	108661	12.9%
JAPAN	70414	8.4%
FRANCE	65031	7.7%
SOUTH KOREA	26789	3.2%
ITALY	15914	1.9%
MARTINIQUE	2	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
united	662965	25.1%
states	554304	21.0%
of	554304	21.0%
america	554304	21.0%
kingdom	108661	4.1%
japan	70414	2.7%
france	65031	2.5%
south	26789	1.0%
korea	26789	1.0%
italy	15914	0.6%

Most occurring characters

Value	Count	Frequency (%)
A	1911476	12.0%
E	1863395	11.7%
T	1814278	11.4%
	1798362	11.3%
I	1341848	8.4%
S	1135397	7.1%
N	907073	5.7%
D	771626	4.8%
O	716543	4.5%
U	689756	4.3%
Other values (12)	2991321	18.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	14142713	88.7%
Space Separator	1798362	11.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1911476	13.5%
E	1863395	13.2%
T	1814278	12.8%
I	1341848	9.5%
S	1135397	8.0%
N	907073	6.4%
D	771626	5.5%
O	716543	5.1%
U	689756	4.9%
M	662967	4.7%
Other values (11)	2328354	16.5%

Space Separator

Value	Count	Frequency (%)
	1798362	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14142713	88.7%
Common	1798362	11.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1911476	13.5%
E	1863395	13.2%
T	1814278	12.8%
I	1341848	9.5%
S	1135397	8.0%
N	907073	6.4%
D	771626	5.5%
O	716543	5.1%
U	689756	4.9%
M	662967	4.7%
Other values (11)	2328354	16.5%

Common

Value	Count	Frequency (%)
	1798362	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15941075	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1911476	12.0%
E	1863395	11.7%
T	1814278	11.4%
	1798362	11.3%
I	1341848	8.4%
S	1135397	7.1%
N	907073	5.7%
D	771626	4.8%
O	716543	4.5%
U	689756	4.3%
Other values (12)	2991321	18.8%

prop_market_id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	58
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	71586.9801

Minimum	369
Maximum	116356
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	369
5-th percentile	369
Q1	60039
median	95602
Q3	95656
95-th percentile	95664
Maximum	116356
Range	115987
Interquartile range (IQR)	35617

Descriptive statistics

Standard deviation	39165.98576
Coefficient of variation (CV)	0.547110462
Kurtosis	-0.4814647598
Mean	71586.9801
Median Absolute Deviation (MAD)	54
Skewness	-1.169138482
Sum	6.021288277 × 10¹⁰
Variance	1533974440
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
95602	229390	27.3%
95656	184846	22.0%
369	108616	12.9%
95612	90745	10.8%
407	62111	7.4%
95664	44193	5.3%
60039	35406	4.2%
60041	29015	3.4%
90988	26760	3.2%
426	15360	1.8%
Other values (48)	14673	1.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
369	108616	12.9%
407	62111	7.4%
426	15360	1.8%
60037	527	0.1%
60039	35406	4.2%
60041	29015	3.4%
60475	113	< 0.1%
61469	115	< 0.1%
61514	3548	0.4%
90988	26760	3.2%

Value	Count	Frequency (%)
116356	2423	0.3%
116316	2	< 0.1%
108347	1	< 0.1%
108227	103	< 0.1%
102274	174	< 0.1%
102132	554	0.1%
102059	1	< 0.1%
102046	20	< 0.1%
102045	1	< 0.1%
102007	52	< 0.1%

prop_submarket_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	294
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	106494.2707

Minimum	60556
Maximum	116928
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	60556
5-th percentile	91279
Q1	98238
median	109153
Q3	110287
95-th percentile	114514
Maximum	116928
Range	56372
Interquartile range (IQR)	12049

Descriptive statistics

Standard deviation	7384.185494
Coefficient of variation (CV)	0.06933880526
Kurtosis	2.792948565
Mean	106494.2707
Median Absolute Deviation (MAD)	1134
Skewness	-1.39997588
Sum	8.957392846 × 10¹⁰
Variance	54526195.41
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
110287	113100	13.4%
96812	81095	9.6%
110029	51658	6.1%
108670	49141	5.8%
96809	38493	4.6%
108577	31658	3.8%
109153	25332	3.0%
109090	19964	2.4%
108046	17407	2.1%
113644	17379	2.1%
Other values (284)	395888	47.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
60556	24	< 0.1%
60590	1917	0.2%
84199	2	< 0.1%
85867	3772	0.4%
85868	5285	0.6%
86632	609	0.1%
89450	117	< 0.1%
90991	254	< 0.1%
90992	3462	0.4%
90995	804	0.1%

Value	Count	Frequency (%)
116928	1135	0.1%
116905	80	< 0.1%
116840	622	0.1%
116822	9	< 0.1%
116814	7	< 0.1%
116786	985	0.1%
116768	10	< 0.1%
116737	19	< 0.1%
116724	99	< 0.1%
116723	29	< 0.1%

prop_room_capacity
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	698
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	631.1164573

Minimum	-9998
Maximum	19235
Zeros	1770
Zeros (%)	0.2%
Negative	10401
Negative (%)	1.2%
Memory size	6.4 MiB

Quantile statistics

Minimum	-9998
5-th percentile	31
Q1	144
median	306
Q3	770
95-th percentile	3066
Maximum	19235
Range	29233
Interquartile range (IQR)	626

Descriptive statistics

Standard deviation	1573.071335
Coefficient of variation (CV)	2.492521494
Kurtosis	24.15277449
Mean	631.1164573
Median Absolute Deviation (MAD)	218
Skewness	-3.144379732
Sum	530841519
Variance	2474553.424
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	12256	1.5%
-9998	10401	1.2%
1500	6435	0.8%
711	5956	0.7%
135	5129	0.6%
3770	4862	0.6%
4049	4641	0.6%
2500	4615	0.5%
4008	4580	0.5%
316	4570	0.5%
Other values (688)	777670	92.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-9998	10401	1.2%
0	1770	0.2%
1	282	< 0.1%
2	70	< 0.1%
3	160	< 0.1%
4	332	< 0.1%
5	629	0.1%
6	450	0.1%
7	263	< 0.1%
8	304	< 0.1%

Value	Count	Frequency (%)
19235	1	< 0.1%
5005	4068	0.5%
4204	3821	0.5%
4049	4641	0.6%
4008	4580	0.5%
4004	4347	0.5%
3933	4465	0.5%
3770	4862	0.6%
3700	2947	0.4%
3680	316	< 0.1%

prop_review_score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	4037
Distinct (%)	0.5%
Missing	8
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	4.024047683

Minimum	0
Maximum	5
Zeros	5809
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	0
5-th percentile	3.2
Q1	3.8
median	4.1
Q3	4.4
95-th percentile	4.6
Maximum	5
Range	5
Interquartile range (IQR)	0.6

Descriptive statistics

Standard deviation	0.5471696756
Coefficient of variation (CV)	0.1359749483
Kurtosis	18.77027841
Mean	4.024047683
Median Absolute Deviation (MAD)	0.3
Skewness	-3.086796013
Sum	3384654.674
Variance	0.2993946539
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.4	77198	9.2%
4.3	74259	8.8%
4.5	73048	8.7%
4	72798	8.7%
4.2	72747	8.6%
4.1	67897	8.1%
3.9	53062	6.3%
3.8	43638	5.2%
3.7	42907	5.1%
3.6	39779	4.7%
Other values (4027)	223774	26.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5809	0.7%
0.7727272727	1	< 0.1%
1	104	< 0.1%
1.3	1	< 0.1%
1.4	2	< 0.1%
1.4	36	< 0.1%
1.4	1	< 0.1%
1.423389169	1	< 0.1%
1.5	100	< 0.1%
1.6	1	< 0.1%

Value	Count	Frequency (%)
5	799	0.1%
4.9225	20	< 0.1%
4.9164	2	< 0.1%
4.9	2	< 0.1%
4.9	6	< 0.1%
4.9	6	< 0.1%
4.9	4	< 0.1%
4.9	4	< 0.1%
4.9	9	< 0.1%
4.9	3	< 0.1%

prop_review_count
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	4626
Distinct (%)	0.5%
Missing	8
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2160.753578

Minimum	0
Maximum	32399
Zeros	5831
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	0
5-th percentile	39
Q1	306
median	937
Q3	2550
95-th percentile	8115
Maximum	32399
Range	32399
Interquartile range (IQR)	2244

Descriptive statistics

Standard deviation	3075.169206
Coefficient of variation (CV)	1.423192925
Kurtosis	7.156989011
Mean	2160.753578
Median Absolute Deviation (MAD)	748
Skewness	2.45832707
Sum	1817424960
Variance	9456665.647
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5831	0.7%
36	2065	0.2%
2	1947	0.2%
1	1791	0.2%
37	1589	0.2%
7	1499	0.2%
1154	1458	0.2%
52	1359	0.2%
34	1301	0.2%
200	1288	0.2%
Other values (4616)	820979	97.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5831	0.7%
1	1791	0.2%
2	1947	0.2%
3	1283	0.2%
4	1040	0.1%
5	899	0.1%
6	1031	0.1%
7	1499	0.2%
8	823	0.1%
9	695	0.1%

Value	Count	Frequency (%)
32399	72	< 0.1%
29176	23	< 0.1%
24518	157	< 0.1%
23715	92	< 0.1%
22111	60	< 0.1%
20354	7	< 0.1%
18353	35	< 0.1%
17691	88	< 0.1%
17197	1	< 0.1%
16292	62	< 0.1%

prop_hostel_bool
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.5 MiB

0	838686
1	2429

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	841115
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	838686	99.7%
1	2429	0.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	838686	99.7%
1	2429	0.3%

Most occurring characters

Value	Count	Frequency (%)
0	838686	99.7%
1	2429	0.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	841115	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	838686	99.7%
1	2429	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	841115	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	838686	99.7%
1	2429	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	841115	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	838686	99.7%
1	2429	0.3%

srch_local_date
Categorical

HIGH CORRELATION

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.7 MiB

2014-09-03	39487
2014-09-09	38261
2014-09-08	37843
2014-09-02	37839
2014-09-04	37662
Other values (23)	650023

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	8411150
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2014-09-13
2nd row	2014-09-13
3rd row	2014-09-13
4th row	2014-09-13
5th row	2014-09-13

Common Values

Value	Count	Frequency (%)
2014-09-03	39487	4.7%
2014-09-09	38261	4.5%
2014-09-08	37843	4.5%
2014-09-02	37839	4.5%
2014-09-04	37662	4.5%
2014-09-17	37515	4.5%
2014-09-10	36488	4.3%
2014-09-15	35691	4.2%
2014-09-11	35239	4.2%
2014-09-12	34176	4.1%
Other values (18)	470914	56.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2014-09-03	39487	4.7%
2014-09-09	38261	4.5%
2014-09-08	37843	4.5%
2014-09-02	37839	4.5%
2014-09-04	37662	4.5%
2014-09-17	37515	4.5%
2014-09-10	36488	4.3%
2014-09-15	35691	4.2%
2014-09-11	35239	4.2%
2014-09-12	34176	4.1%
Other values (18)	470914	56.0%

Most occurring characters

Value	Count	Frequency (%)
0	2031576	24.2%
-	1682230	20.0%
1	1255419	14.9%
2	1151305	13.7%
4	936046	11.1%
9	862430	10.3%
3	120842	1.4%
5	97575	1.2%
8	94122	1.1%
7	90693	1.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6728920	80.0%
Dash Punctuation	1682230	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2031576	30.2%
1	1255419	18.7%
2	1151305	17.1%
4	936046	13.9%
9	862430	12.8%
3	120842	1.8%
5	97575	1.5%
8	94122	1.4%
7	90693	1.3%
6	88912	1.3%

Dash Punctuation

Value	Count	Frequency (%)
-	1682230	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	8411150	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2031576	24.2%
-	1682230	20.0%
1	1255419	14.9%
2	1151305	13.7%
4	936046	11.1%
9	862430	10.3%
3	120842	1.4%
5	97575	1.2%
8	94122	1.1%
7	90693	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8411150	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2031576	24.2%
-	1682230	20.0%
1	1255419	14.9%
2	1151305	13.7%
4	936046	11.1%
9	862430	10.3%
3	120842	1.4%
5	97575	1.2%
8	94122	1.1%
7	90693	1.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	srch_id	prop_key	srch_date_time	srch_visitor_id	srch_visitor_visit_nbr	srch_visitor_loc_country	srch_visitor_loc_region	srch_visitor_loc_city	srch_visitor_wr_member	srch_posa_continent	srch_posa_country	srch_hcom_destination_id	srch_dest_longitude	srch_dest_latitude	srch_ci	srch_co	srch_ci_day	srch_co_day	srch_los	srch_bw	srch_adults_cnt	srch_rm_cnt	srch_device	srch_currency	prop_price_without_discount_local	prop_price_without_discount_usd	prop_price_with_discount_local	prop_price_with_discount_usd	prop_imp_drr	prop_brand_bool	prop_starrating	prop_super_region	prop_continent	prop_country	prop_market_id	prop_submarket_id	prop_room_capacity	prop_review_score	prop_review_count	srch_local_date
0	-1046322713	257690	2014-09-13 18:37:32	9373b009-4e10-495a-afae-204dd1fe4b7c	5	TWN	TPE	TAIPEI	Signed in - Persistent\|WR Member\|Remembered FC Member	ASIA	TAIWAN, REPUBLIC OF CHINA	728660	135.498154	34.701897	2015-02-25	2015-02-28	4	7	3	164	2.0	1	DESKTOP	TWD	5605.0	186.72	3356.0	111.80	0	1	3.5	APAC	ASIA	JAPAN	60041	109140	575	4.1	403.0	2014-09-13
1	-1046322713	3066218	2014-09-13 18:37:32	9373b009-4e10-495a-afae-204dd1fe4b7c	5	TWN	TPE	TAIPEI	Signed in - Persistent\|WR Member\|Remembered FC Member	ASIA	TAIWAN, REPUBLIC OF CHINA	728660	135.498154	34.701897	2015-02-25	2015-02-28	4	7	3	164	2.0	1	DESKTOP	TWD	4614.0	153.71	2769.0	92.24	1	0	3.0	APAC	ASIA	JAPAN	60041	109140	339	3.6	101.0	2014-09-13
2	-1046322713	2271987	2014-09-13 18:37:32	9373b009-4e10-495a-afae-204dd1fe4b7c	5	TWN	TPE	TAIPEI	Signed in - Persistent\|WR Member\|Remembered FC Member	ASIA	TAIWAN, REPUBLIC OF CHINA	728660	135.498154	34.701897	2015-02-25	2015-02-28	4	7	3	164	2.0	1	DESKTOP	TWD	14026.0	467.25	2821.0	93.98	0	1	3.5	APAC	ASIA	JAPAN	60041	109140	179	4.1	1189.0	2014-09-13
3	-1046322713	3308025	2014-09-13 18:37:32	9373b009-4e10-495a-afae-204dd1fe4b7c	5	TWN	TPE	TAIPEI	Signed in - Persistent\|WR Member\|Remembered FC Member	ASIA	TAIWAN, REPUBLIC OF CHINA	728660	135.498154	34.701897	2015-02-25	2015-02-28	4	7	3	164	2.0	1	DESKTOP	TWD	14308.0	476.65	5202.0	173.30	0	1	5.0	APAC	ASIA	JAPAN	60041	98278	272	4.8	221.0	2014-09-13
4	-1046322713	3222046	2014-09-13 18:37:32	9373b009-4e10-495a-afae-204dd1fe4b7c	5	TWN	TPE	TAIPEI	Signed in - Persistent\|WR Member\|Remembered FC Member	ASIA	TAIWAN, REPUBLIC OF CHINA	728660	135.498154	34.701897	2015-02-25	2015-02-28	4	7	3	164	2.0	1	DESKTOP	TWD	5445.0	181.39	2589.0	86.25	0	0	3.0	APAC	ASIA	JAPAN	60041	109140	198	3.9	702.0	2014-09-13
5	-1046322713	253808	2014-09-13 18:37:32	9373b009-4e10-495a-afae-204dd1fe4b7c	5	TWN	TPE	TAIPEI	Signed in - Persistent\|WR Member\|Remembered FC Member	ASIA	TAIWAN, REPUBLIC OF CHINA	728660	135.498154	34.701897	2015-02-25	2015-02-28	4	7	3	164	2.0	1	DESKTOP	TWD	6292.0	209.61	5348.0	178.16	1	1	4.0	APAC	ASIA	JAPAN	60041	109140	643	4.3	694.0	2014-09-13
6	-1046322713	3906821	2014-09-13 18:37:32	9373b009-4e10-495a-afae-204dd1fe4b7c	5	TWN	TPE	TAIPEI	Signed in - Persistent\|WR Member\|Remembered FC Member	ASIA	TAIWAN, REPUBLIC OF CHINA	728660	135.498154	34.701897	2015-02-25	2015-02-28	4	7	3	164	2.0	1	DESKTOP	TWD	3132.0	104.34	3132.0	104.34	1	0	3.0	APAC	ASIA	JAPAN	60041	109140	104	4.7	10.0	2014-09-13
7	-1046322713	542765	2014-09-13 18:37:32	9373b009-4e10-495a-afae-204dd1fe4b7c	5	TWN	TPE	TAIPEI	Signed in - Persistent\|WR Member\|Remembered FC Member	ASIA	TAIWAN, REPUBLIC OF CHINA	728660	135.498154	34.701897	2015-02-25	2015-02-28	4	7	3	164	2.0	1	DESKTOP	TWD	3523.0	117.36	2672.0	89.01	0	1	4.0	APAC	ASIA	JAPAN	60041	109140	134	4.0	284.0	2014-09-13
8	-1046322713	522960	2014-09-13 18:37:32	9373b009-4e10-495a-afae-204dd1fe4b7c	5	TWN	TPE	TAIPEI	Signed in - Persistent\|WR Member\|Remembered FC Member	ASIA	TAIWAN, REPUBLIC OF CHINA	728660	135.498154	34.701897	2015-02-25	2015-02-28	4	7	3	164	2.0	1	DESKTOP	TWD	5686.0	189.42	3295.0	109.77	0	1	3.5	APAC	ASIA	JAPAN	60041	109140	348	4.3	1800.0	2014-09-13
9	-1046322713	349853	2014-09-13 18:37:32	9373b009-4e10-495a-afae-204dd1fe4b7c	5	TWN	TPE	TAIPEI	Signed in - Persistent\|WR Member\|Remembered FC Member	ASIA	TAIWAN, REPUBLIC OF CHINA	728660	135.498154	34.701897	2015-02-25	2015-02-28	4	7	3	164	2.0	1	DESKTOP	TWD	1994.0	66.43	1934.0	64.43	1	0	3.0	APAC	ASIA	JAPAN	60041	109140	302	3.8	475.0	2014-09-13

Last rows

	srch_id	prop_key	srch_date_time	srch_visitor_id	srch_visitor_visit_nbr	srch_visitor_loc_country	srch_visitor_loc_region	srch_visitor_loc_city	srch_visitor_wr_member	srch_posa_continent	srch_posa_country	srch_hcom_destination_id	srch_dest_longitude	srch_dest_latitude	srch_ci	srch_co	srch_ci_day	srch_co_day	srch_los	srch_bw	srch_adults_cnt	srch_rm_cnt	srch_device	srch_currency	prop_price_without_discount_local	prop_price_without_discount_usd	prop_price_with_discount_local	prop_price_with_discount_usd	prop_imp_drr	prop_brand_bool	prop_starrating	prop_super_region	prop_continent	prop_country	prop_market_id	prop_submarket_id	prop_room_capacity	prop_review_score	prop_review_count	srch_local_date
841105	964783409	243425	2014-09-06 14:16:47	40db5c41-4658-439b-ab81-ed6fed7fc8b9	5	UNITED STATES OF AMERICA	OR	PORTLAND	NaN	NaN	US	1506246	-73.986473	40.75668	2014-09-07	2014-09-09	1	3	2	1	2.0	1	DESKTOP	NaN	519.0	519.0	339.0	339.0	0	0	4.0	AMER	NORTHAMERICA	UNITED STATES OF AMERICA	95656	96810	423	3.7	1827.0	2014-09-06
841106	964783409	258275	2014-09-06 14:16:47	40db5c41-4658-439b-ab81-ed6fed7fc8b9	5	UNITED STATES OF AMERICA	OR	PORTLAND	NaN	NaN	US	1506246	-73.986473	40.75668	2014-09-07	2014-09-09	1	3	2	1	2.0	1	DESKTOP	NaN	619.0	619.0	439.0	439.0	0	1	4.0	AMER	NORTHAMERICA	UNITED STATES OF AMERICA	95656	96809	1311	4.2	3505.0	2014-09-06
841107	964783409	324155	2014-09-06 14:16:47	40db5c41-4658-439b-ab81-ed6fed7fc8b9	5	UNITED STATES OF AMERICA	OR	PORTLAND	NaN	NaN	US	1506246	-73.986473	40.75668	2014-09-07	2014-09-09	1	3	2	1	2.0	1	DESKTOP	NaN	569.0	569.0	254.0	254.0	0	1	3.0	AMER	NORTHAMERICA	UNITED STATES OF AMERICA	95656	96808	158	4.1	442.0	2014-09-06
841108	964783409	495424	2014-09-06 14:16:47	40db5c41-4658-439b-ab81-ed6fed7fc8b9	5	UNITED STATES OF AMERICA	OR	PORTLAND	NaN	NaN	US	1506246	-73.986473	40.75668	2014-09-07	2014-09-09	1	3	2	1	2.0	1	DESKTOP	NaN	539.0	539.0	299.0	299.0	0	1	4.0	AMER	NORTHAMERICA	UNITED STATES OF AMERICA	95656	108612	222	4.4	761.0	2014-09-06
841109	964783409	285185	2014-09-06 14:16:47	40db5c41-4658-439b-ab81-ed6fed7fc8b9	5	UNITED STATES OF AMERICA	OR	PORTLAND	NaN	NaN	US	1506246	-73.986473	40.75668	2014-09-07	2014-09-09	1	3	2	1	2.0	1	DESKTOP	NaN	419.0	419.0	388.0	388.0	1	1	4.0	AMER	NORTHAMERICA	UNITED STATES OF AMERICA	95656	96812	804	3.6	2745.0	2014-09-06
841110	964783409	249748	2014-09-06 14:16:47	40db5c41-4658-439b-ab81-ed6fed7fc8b9	5	UNITED STATES OF AMERICA	OR	PORTLAND	NaN	NaN	US	1506246	-73.986473	40.75668	2014-09-07	2014-09-09	1	3	2	1	2.0	1	DESKTOP	NaN	334.0	334.0	284.0	284.0	1	1	4.0	AMER	NORTHAMERICA	UNITED STATES OF AMERICA	95656	85868	251	4.1	1928.0	2014-09-06
841111	964783409	255778	2014-09-06 14:16:47	40db5c41-4658-439b-ab81-ed6fed7fc8b9	5	UNITED STATES OF AMERICA	OR	PORTLAND	NaN	NaN	US	1506246	-73.986473	40.75668	2014-09-07	2014-09-09	1	3	2	1	2.0	1	DESKTOP	NaN	649.0	649.0	269.0	269.0	0	1	4.0	AMER	NORTHAMERICA	UNITED STATES OF AMERICA	95656	96809	712	4.2	605.0	2014-09-06
841112	964783409	244678	2014-09-06 14:16:47	40db5c41-4658-439b-ab81-ed6fed7fc8b9	5	UNITED STATES OF AMERICA	OR	PORTLAND	NaN	NaN	US	1506246	-73.986473	40.75668	2014-09-07	2014-09-09	1	3	2	1	2.0	1	DESKTOP	NaN	285.0	285.0	225.0	225.0	0	0	3.0	AMER	NORTHAMERICA	UNITED STATES OF AMERICA	95656	96809	369	4.0	5305.0	2014-09-06
841113	964783409	259221	2014-09-06 14:16:47	40db5c41-4658-439b-ab81-ed6fed7fc8b9	5	UNITED STATES OF AMERICA	OR	PORTLAND	NaN	NaN	US	1506246	-73.986473	40.75668	2014-09-07	2014-09-09	1	3	2	1	2.0	1	DESKTOP	NaN	559.0	559.0	314.0	314.0	0	1	4.0	AMER	NORTHAMERICA	UNITED STATES OF AMERICA	95656	96812	770	4.2	1809.0	2014-09-06
841114	964783409	252506	2014-09-06 14:16:47	40db5c41-4658-439b-ab81-ed6fed7fc8b9	5	UNITED STATES OF AMERICA	OR	PORTLAND	NaN	NaN	US	1506246	-73.986473	40.75668	2014-09-07	2014-09-09	1	3	2	1	2.0	1	DESKTOP	NaN	599.0	599.0	474.0	474.0	0	1	4.0	AMER	NORTHAMERICA	UNITED STATES OF AMERICA	95656	96812	1949	4.3	1706.0	2014-09-06

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values